Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | |
RetailTransactionLineItemSequenceNumber (FK)(PK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | |
FullMICR | The complete string of characters read from the MICR (Magnetic Ink Character Recognition) strip. Content varies by Country and/or Financial Institution but it usually contains BankID, CheckAccountNumber and CheckSequenceNumber - but there may be more data encoded in the MICR. | ED_FLL_MICR | IdentityAlphaNumeric | varchar(20) | |
BankID | The unique identifier of the bank or third party authorization center. | ID_BK_CHK | Identity | integer | |
CheckAccountNumber | The check account number of CUSTOMERs whose checks have been previously honored or rejected. Retaining a check history by CUSTOMER provides the RETAIL STORE with a means of tender authorization. | ID_ACNT_CHK | Identity | integer | |
CheckAccountNumberEntryMethodCode | A code denoting how the CheckAccountNumber was entered into the system. | LU_MTH_ACNT_ENR | Code | varchar(20) | |
CheckSequenceNumber | A unique sequence number relating to a particular check authorization. | AI_CHK | LineNumber | smallint | |
CheckSequenceNumberEntryMethodCode | A code denoting how the CheckSequenceNumber was entered into the system. | LU_MTH_SQN_ENR | Code | varchar(20) | |
PersonalIDRequiredTypeCode | Identifies the type of personal identification required to authorize tender. Examples include driver's license, a second credit card, social security card, etc. | TY_ID_PRSL_RQ | Code2 | char(2) | |
PersonalIDNumber | The personal identification number that must be keyed by an individual at the point of sale when paying by personal check. | ID_PRSL_AZN | Identity | integer | |
AdjudicationCode | A code to denote that approval has been received from the authorization center. | ID_ADJN_CHK | Code4 | char(4) | |
CustomerBirthDate | The customer's date of birth captured as part of the personal data required to verify their identity and authorize their use of a check to pay for a purchase. | DC_BRT_CHK | DateCalendarDay | char(2) | |
CheckCardNumber | The number from a bank issued card guaranteeing checks up to a certain value. | ID_CRD_CHK | Name | varchar(40) | |
CheckTypeCode | A code the designates whether the check is a PERSONAL or BUSINESS check. | CD_CK_TYP | Code | varchar(20) | |